Precision Software Applications Silver Collection 1

home *** CD-ROM | disk | FTP | other *** search

/ Precision Software Appli…tions Silver Collection 1 / Precision Software Applications Silver Collection Volume One (PSM) (1993).iso / tutor / dbaseiii.exe / M501.T < prev next >

Wrap

Text File | 1986-07-31 | 6KB | 325 lines

*5-010 xÇÇÅ rââ┘ Introduction to dBASE III PLUS rÑâ∙∙ rªâ┘ r¿â┘Session 5 r▒â┘ r│â∙∙ r┤â┘ r╢â∙Format r╝â┘ ö râäτ ├─ röïÅIn this session you create a customized röìÅformat for the structure of a database å röÅÅfile. r└ÅÅ rñù┘ Press r¡ù∙──┘ r▒ù┘ to continue or r─ù∙F5 r╞ù┘ to exit q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, *5-014 xÇÇ╨ r¥îÅ º r¥ìÅ When you entered data in the ToDoList r¥ÄÅ º r¥ÅÅ database file, you used the format ä r¥ÉÅ º r¥æÅ provided by dBASE III PLUS. ï r¥ÆÅ º q╧ÿÅP,6,,,,, a1,P,,,,, *5-020 r┼æ╕───┘ u╚É╕ î│┐ l╟ä╕ û─ q╧ÿ╕N,,,,,, a7,P,,,,, *5-030 rüü╨Record No. ç 1 rüé╨WHAT rüâ╨WHO rüä╨PHONE rüà╨WHEN rüå╨WHERE rüç╨ACTIVITY rëé╨ rîé╨ rìéé Ö rªé╨ rìâé ₧ rìäé ì rìàé ê rìåé Ö rìçémemo q╧ÿéP,4,,,,, a1,P,,,,, *5-040 rñòç┌ ¬─┐ d╧ûç│┘ l╬ùç ¬─└ rñûç│ rÑûÅ Press r¼û° ──┘ r▓ûÅ to continue or r─ûçF5 r╞ûÅ to exit réò╕ Ä─┐ dÉû╕│┘ lÅù╕ Ä─└ uüû╕│┌ râû╕F9 to review q╧ÿ╨S,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, a8,T,5-010,,,&H0043, *5-050 xÇÇÅ rââ┘ Format ┼ râäτ ├─ röèÅIn this session, you use a new database file röîÅto create a customized format. râù╕ F9 to review rñù┘ Press r¡ù∙──┘ r▒ù┘ to continue or r─ù∙F5 r╞ù┘ to exit q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, a8,T,5-010,,,&H0043, *5-060 röèÅThe name of the new file is r░èçBusiness r╕èÅ. ç röîÅIt has been set up by a distributor of gag props röÄÅsuch as whoopee cushions, insect ice cubes, and röÉÅsquirting carnations. The name of the distributor röÆÅis V. F. Vase of Meckenutoc, OK. q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, a8,T,5-010,,,&H0043, *5-062 xÇÇ╨ rüé╨ ¬═ rüâ╨FIELDNAME rìâé ₧ rüà╨FIELDNAME rìàé Å rüç╨FIELDNAME rìçé ì rüë╨ ┤─ rüè╨FIELDNAME rìèé ¿ rüï╨FIELDNAME rìïé / / rüî╨FIELDNAME rìîé à . rüì╨FIELDNAME rììé? r£ÄÅ « r£ÅÅ The format you create will look like this. r£ÉÅ « rºôç ¬ rüö╕┌ Ä─┐ rºöÅ Press r«ö° ──┘ r┤öÅ to continue or r╞öçF5 r╚öÅ to exit rüò╕│ F9 to review │ rºòç ¬ rüû╕└ Ä─┘ rüùé É ║<A:>║BUSINESS Å ║Rec: Å ║ å ║ ç q╧ÿ╨S,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, a8,T,5-010,,,&H0043, *5-064 xÇÇÅ rââ┘ Format ┼ râäτ ├─ ræëÅCustomized formats are useful for making different ræïÅpresentations of the information in a database file. rüùÅ râù╕ F9 to review rñù┘ Press r¡ù∙──┘ r▒ù┘ to continue or r─ù∙F5 r╞ù┘ to exit q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, a8,T,5-010,,,&H0043, *5-066 ræëÅLike the paper forms used in offices, customized ræïÅformats have many uses: ₧ ræìÅ ä ròìç∙ rûìÅ inventory sheet for the reordering of rÿÄÅpopular products ròÉç∙ rûÉÅ support material for a monthly sales report ròÆç∙ rûÆÅ fact sheet, or employee application q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, a8,T,5-010,,,&H0043, *5-067 råçç┌ ö─┬ å─┐ råêç│INVOICE r¢êç│ Date róêç│ råëç╞ ö═╧ å═╡ ç r¬ëÅYou can use dBASE III PLUS to å råèç│Customer name róèç│ råïç│and address É │ ç r¬ïÅcreate a customized invoice. råîç├ ¢─┤ råìç│ rêìçItems ordered ï_ róìç│ ç r¬ìÅ Ö råÄç│ rùÄç ï │ ç r¬ÄÅIn it, you include only that à råÅç│ rêÅçItems sent rûÅç ï_ róÅç│ råÉç│ ròÉç ì │ ç r¬ÉÅinformation which applies to råæç│ rêæçCost rûæç ï_ róæç│ råÆç│ ròÆç ì │ rñÆç å r¬ÆÅthat particular invoice. råôç│ rêôçAmount due rûôç ï_ róôç│ råöç└ ¢─┘ q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, a8,T,5-010,,,&H0043, *5-068 råçÅ á råêÅ ï r¢êÅ ê råëÅ ï You can design a format to present the information r┼ëÅ råèÅ Ä róèÅ råïÅ ï in your database file for your specific needs. ç råîÅ ¥ råìÅ ╕ råÄÅ ï rÿÄÅ æ r¬ÄÅ £ råÅÅ î rûÅÅ ì råÉÅ ï ròÉÅ « r─ÉÅ råæÅ ï ròæÅ « råÆÅ ï ròÆÅ » råôÅ î rûôÅ ì råöÅ ¥ q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, a8,T,5-010,,,&H0043, *5-070 ræëÅThe format you are about to design for the Business ræïÅdatabase file, is a form which will be used by the ræìÅMarketing Department. ræÉÅIt will provide Marketing with the information ræÆÅnecessary to compile lists of the biggest buyers ræöÅof gag props. q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, a8,T,5-010,,,&H0043, *5-072 ròëÅBusiness database file contains more information ç ræïÅabout each customer rÑïÅthan Marketing needs to know. ræìÅ ò ræÄÅFor example, the address of the customer is irrelevant ræÉÅto this application. Therefore, you will not include ræÆÅthe address in the new form. ò ræöÅ ì q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, a8,T,5-010,,,&H0043, *5-074 ræëÅThe format you create is stored in a new file, å ræïÅseparate from the Business database file. Just like ræìÅwhen you created ToDoSort from ToDoList, dBASE III PLUS ræÄÅ ╢ ræÅÅwill ask you for a new file name. The name of the new ræÉÅ ╢ rææÅformat file is ráæçMarket rªæÅ. á ræÆÅ ╢ q╧ÿÅS,,,,,, a7,G,,,,, a8,P,,,,&H0D, a8,C,M002.T,,,&H003F, a8,T,5-010,,,&H0043, *5-078 xÇÇ╨ rüä╨A> rùäÅ ñ rùàÅ To begin creating the new format, rùåÅ ñ rùçÅ type r₧ç° dbase rÑçÅ û rùêÅ ñ rùëÅ æ then press r│ë° ──┘ r╣ëÅ rùèÅ ñ qâä╨K,,10A/I,,,, è a7,G,,,,, a8,C,M502.T,,,dbase à , a8,C,M502.T,,,dBASE à , a8,C,M502.T,,,DBASE à , a8,C,M502.T,,,dBase à , a8,C,M502.T,,,Dbase à , a8,C,M502.T,,,dbase à , a8,C,M502.T,,,dBASE à , a8,C,M502.T,,,DBASE à , a8,C,M502.